Bypass Data Provider Import Items

Overview

Bypass the updating of specific items when performing a Data Provider import. When items are updated from another source other than the main Data Provider import and the main Data Provider import should not update these items.

TSOPT

TSOpt Field

The TSOpt field was added to be used with Trade Service and the TSOpt field. If the TSOpt field is already being used, it is possible to use an open CVal field instead.

Finding the TSOpt field

Pricing Rules Manager - Profile

The TSOpt can also be found on the Profile tab in the Pricing Rules Manager in order to update an entire pricing profile at a time.

Pricing Rules Manager - Item Pricing

The TSOpt can also be found on the ItemPricing tab in the Pricing Rules Manager in order to update multiple items at a time.

Item Manager

The TSOpt can be found and changed individually in the Item Manager.

Updating the TSOpt Field - Item Manager

The default value for the TSOpt field is “0”.

Right Click the TSOpt you want to change and select Override.

Enter the new TSOpt value.

Enter an integer value other that “0”

Click the Save button to update the Item’s TSOpt value.

Updating the TSOpt Field - Pricing Rules Manager

The default value for the TSOpt field is “0”.

Right Click the TSOpt you want to change and select Override.

Enter the new TSOpt value.

Enter an integer value other that “0”

To Apply the value to all items in the Item Pricing tab, right click the TSOpt field and select “Apply Selected -> Entire Column”

Click the “Process” button to apply the updated TSOpt value to the item(s).

Using TSOpt in Import

Overview

The TSOpt field can be used in the import formulas to exclude data from being updated.

Setting the Formula

From the Import Template dialog, select the “...” of the field you want to add the TSOpt formula.

We can then start added a IF statement in the Formula Editor

Expand the Existing Values in the right hand tree view and find TSOpt.

Double click the TSOpt to add it to the Formula

Finish out the IF statement structure as pictured below

For the Else Output Double click the SkipUpdated selecting in the right hand tree view

The formula will now check the TSOpt column for any existing Part Number.

If the TSOpt is equal to 0 (no value set on the Item’s TSOpt field), it will update the List Price value with the {price} value from the import.

Else If the TSOpt value id set to anything, it will skip updating the List Price field for that item.

NOTES

You can also use the Select Case structure if you want to perform different options for different TSOpts

Select Case ExistingColumns("TSOpt")

Case 1

Output = SkipUpdating()

Case 2

Output = {price} * 1.25

Case Else

Output = {price}

End Select